CREATE PROCEDURE  [dbo].[sp_asi_CreateLogins]
AS
    -- script to fix up a restored iMIS db for iMIS15
    --    Henry Huey 13 Sept 2006
    --    Paul Bradshaw 15 Feb 2010
    SET NOCOUNT ON

    ------------------------------------
    -- create the IMIS role if necessary
    ------------------------------------
    IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE [name] = 'IMIS' AND [type_desc] = 'DATABASE_ROLE' )
    BEGIN
        CREATE ROLE [IMIS] AUTHORIZATION [dbo]
    END

GO
GRANT EXECUTE ON  [dbo].[sp_asi_CreateLogins] TO [IMIS]
GO